Dataset info
| Number of variables | 62 |
|---|---|
| Number of observations | 90697 |
| Missing cells | 832241 (14.8%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 165.3 MiB |
| Average record size in memory | 1.9 KiB |
Variables types
| CAT | 37 |
|---|---|
| NUM | 16 |
| BOOL | 8 |
| DATE | 1 |
Reproduction info
| Date of analysis | 2020-05-04 09:29:50.839084 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
Alternative_purchasing_group has 3542 (3.9%) missing values | Missing |
Alternative_purchasing_group has a high cardinality: 561 distinct values | Warning |
ATC has a high cardinality: 1111 distinct values | Warning |
Chemical_/_biological has 7621 (8.4%) missing values | Missing |
consumption has 7514 (8.3%) zeros | Zeros |
consumption_previous_year has 3745 (4.1%) zeros | Zeros |
Current_consumption has 8480 (9.3%) zeros | Zeros |
Dangerous_material_is_charged_with_a_permit has 80310 (88.5%) missing values | Missing |
dangerous_substance has 80326 (88.6%) missing values | Missing |
Date_of_basket_entry has 41213 (45.4%) missing values | Missing |
Date_of_basket_entry has a high cardinality: 54 distinct values | Warning |
Description_Alternative_purchasing_group has 3542 (3.9%) missing values | Missing |
Description_Alternative_purchasing_group has a high cardinality: 561 distinct values | Warning |
Description_outline has 6891 (7.6%) missing values | Missing |
Description_outline has a high cardinality: 306 distinct values | Warning |
European_patent_expires has 89409 (98.6%) missing values | Missing |
For_adults has 86837 (95.7%) missing values | Missing |
Form_of_giving has 52945 (58.4%) missing values | Missing |
GENERY_FATHER has 53724 (59.2%) missing values | Missing |
GENERY_FATHER has a high cardinality: 680 distinct values | Warning |
Inventory has 10370 (11.4%) zeros | Zeros |
Inventory_of_consumption_months has 32934 (36.3%) zeros | Zeros |
Main_outline has 6891 (7.6%) missing values | Missing |
Main_outline has a high cardinality: 306 distinct values | Warning |
Narcotic_/_psychotropic has 41313 (45.6%) missing values | Missing |
Narcotic_/_psychotropic has 46358 (51.1%) zeros | Zeros |
Plant has constant value "7350.0" | Rejected |
Prediction has 8934 (9.9%) zeros | Zeros |
Price_for_absolute_packaging has 1324 (1.5%) zeros | Zeros |
Quantity_in_absolute_packaging has 1324 (1.5%) zeros | Zeros |
Quantity_in_Packaging-Absolute has 1324 (1.5%) zeros | Zeros |
Quantity_in_packing-relative has 64712 (71.3%) zeros | Zeros |
Safety_Stock has 9502 (10.5%) zeros | Zeros |
Send_code_to_Omri has constant value "1.0" | Rejected |
Serving_form has 7904 (8.7%) missing values | Missing |
Serving_form has a high cardinality: 53 distinct values | Warning |
skucode2 has a high cardinality: 3207 distinct values | Warning |
status has constant value "1.0" | Rejected |
Toxic_item has 7362 (8.1%) missing values | Missing |
type_of_packeging has 85285 (94.0%) missing values | Missing |
U#S#_Patent_Expires has 89166 (98.3%) missing values | Missing |
Validity_of_Ministry_of_Health_registration has 86155 (95.0%) missing values | Missing |
Validity_of_Ministry_of_Health_registration has a high cardinality: 83 distinct values | Warning |
VENDOR has a high cardinality: 155 distinct values | Warning |
Current_consumption is highly correlated with consumption and 3 other fields | High Correlation |
consumption is highly correlated with Current_consumption and 2 other fields | High Correlation |
General_purpose_ is highly correlated with General_purpose | High Correlation |
General_purpose is highly correlated with General_purpose_ | High Correlation |
Inventory is highly correlated with Current_consumption and 1 other fields | High Correlation |
Prediction is highly correlated with consumption and 2 other fields | High Correlation |
Quantity_in_Packaging-Absolute is highly correlated with Quantity_in_absolute_packaging | High Correlation |
Quantity_in_absolute_packaging is highly correlated with Quantity_in_Packaging-Absolute | High Correlation |
Safety_Stock is highly correlated with consumption and 3 other fields | High Correlation |
General_purpose_ is highly correlated with General_purpose | High Correlation |
General_purpose is highly correlated with General_purpose_ | High Correlation |
month_year_ is highly correlated with month_year | High Correlation |
month_year is highly correlated with month_year_ | High Correlation |
Volume_marker is highly correlated with Budget_Group | High Correlation |
Budget_Group is highly correlated with Volume_marker | High Correlation |
A_group_of_materials
Categorical
| Distinct count | 38 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 20190 | |
|---|---|
| 20100 | |
| 20120 | |
| 20130 | 7744 |
| 20210 | 5920 |
| Other values (33) |
| Value | Count | Frequency (%) | |
| 20190 | 14723 | 16.2% | |
| 20100 | 11235 | 12.4% | |
| 20120 | 9449 | 10.4% | |
| 20130 | 7744 | 8.5% | |
| 20210 | 5920 | 6.5% | |
| 20140 | 5192 | 5.7% | |
| 20270 | 4324 | 4.8% | |
| 20220 | 3800 | 4.2% | |
| 20180 | 3707 | 4.1% | |
| 20110 | 3031 | 3.3% | |
| Other values (28) | 21572 | 23.8% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 5 |
|---|---|
| Mean length | 4.996063817 |
| Min length | 4 |
ABC
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| C | |
|---|---|
| B | |
| A |
| Value | Count | Frequency (%) | |
| C | 49485 | 54.6% | |
| B | 30334 | 33.4% | |
| A | 10878 | 12.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
Affiliation_Group
Categorical
| Distinct count | 39 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 147 |
| Missing (%) | 0.2% |
| Memory size | 708.6 KiB |
| 20 | |
|---|---|
| 11 | |
| 13 | |
| 24 | |
| 14 | |
| Other values (33) |
| Value | Count | Frequency (%) | |
| 20 | 14504 | 16.0% | |
| 11 | 11556 | 12.7% | |
| 13 | 9668 | 10.7% | |
| 24 | 9137 | 10.1% | |
| 14 | 8010 | 8.8% | |
| 21 | 6052 | 6.7% | |
| 15 | 5254 | 5.8% | |
| 22 | 4072 | 4.5% | |
| 19 | 3955 | 4.4% | |
| 17 | 2889 | 3.2% | |
| Other values (28) | 15453 | 17.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.003241563 |
| Min length | 2 |
| Distinct count | 561 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 3542 |
| Missing (%) | 3.9% |
| Memory size | 708.6 KiB |
| 1734 | 2963 |
|---|---|
| 1591 | 1889 |
| 1875 | 1705 |
| 1068 | 1515 |
| 1823 | 1352 |
| Other values (555) |
| Value | Count | Frequency (%) | |
| 1734 | 2963 | 3.3% | |
| 1591 | 1889 | 2.1% | |
| 1875 | 1705 | 1.9% | |
| 1068 | 1515 | 1.7% | |
| 1823 | 1352 | 1.5% | |
| 1317 | 1309 | 1.4% | |
| 1053 | 1217 | 1.3% | |
| 1642 | 1027 | 1.1% | |
| 1027 | 965 | 1.1% | |
| 1354 | 952 | 1.0% | |
| Other values (550) | 72261 | 79.7% | |
| (Missing) | 3542 | 3.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Distinct count | 1111 |
|---|---|
| Unique (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 1/0/1900 | 6714 |
|---|---|
| ATC: | 1096 |
| ATC:M01AE01 | 887 |
| ATC:C10AA07 | 631 |
| ATC:C10AA05 | 622 |
| Other values (1106) |
| Value | Count | Frequency (%) | |
| 1/0/1900 | 6714 | 7.4% | |
| ATC: | 1096 | 1.2% | |
| ATC:M01AE01 | 887 | 1.0% | |
| ATC:C10AA07 | 631 | 0.7% | |
| ATC:C10AA05 | 622 | 0.7% | |
| ATC:N03AX16 | 618 | 0.7% | |
| ATC:A11AA06 | 611 | 0.7% | |
| ATC:N06BA04 | 587 | 0.6% | |
| ATC:A11CC05 | 545 | 0.6% | |
| ATC:A07FA01 | 531 | 0.6% | |
| Other values (1101) | 77855 | 85.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 11 |
|---|---|
| Mean length | 10.53277396 |
| Min length | 4 |
Basic_unit_of_measure
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| EA | |
|---|---|
| PAC | 14365 |
| KIT | 321 |
| BLS | 24 |
| BT | 22 |
| Value | Count | Frequency (%) | |
| EA | 75965 | 83.8% | |
| PAC | 14365 | 15.8% | |
| KIT | 321 | 0.4% | |
| BLS | 24 | < 0.1% | |
| BT | 22 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 3 |
|---|---|
| Mean length | 2.162188386 |
| Min length | 2 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| B | |
|---|---|
| E | |
| A | |
| D | 5580 |
| H | 102 |
| Value | Count | Frequency (%) | |
| B | 43242 | 47.7% | |
| E | 23065 | 25.4% | |
| A | 18708 | 20.6% | |
| D | 5580 | 6.2% | |
| H | 102 | 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 7621 |
| Missing (%) | 8.4% |
| Memory size | 708.6 KiB |
| 1 | |
|---|---|
| 2 | 2981 |
| Value | Count | Frequency (%) | |
| 1 | 80095 | 88.3% | |
| 2 | 2981 | 3.3% | |
| (Missing) | 7621 | 8.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
chronic
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 428 |
| Missing (%) | 0.5% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | |
| (Missing) | 428 |
| Value | Count | Frequency (%) | |
| 0 | 51192 | 56.4% | |
| 1 | 39077 | 43.1% | |
| (Missing) | 428 | 0.5% |
Consumer_management
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 708.6 KiB |
| ave | |
|---|---|
| pred |
| Value | Count | Frequency (%) | |
| ave | 74914 | 82.6% | |
| pred | 15782 | 17.4% | |
| (Missing) | 1 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.174018986 |
| Min length | 3 |
| Distinct count | 2224 |
|---|---|
| Unique (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.276880129 |
|---|---|
| Minimum | 0.0 |
| Maximum | 15.29536379352081 |
| Zeros | 7514 |
| Zeros (%) | 8.3% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6.720220155 |
| median | 8.45616849 |
| Q3 | 10.76534322 |
| 95-th percentile | 12.8376263 |
| Maximum | 15.29536379 |
| Range | 15.29536379 |
| Interquartile range (IQR) | 4.045123063 |
Descriptive statistics
| Standard deviation | 3.381153499 |
|---|---|
| Coefficient of variation (CV) | 0.4085057953 |
| Kurtosis | 0.6698103026 |
| Mean | 8.276880129 |
| Median Absolute Deviation (MAD) | 2.571665816 |
| Skewness | -0.8771061145 |
| Sum | 750688.1971 |
| Variance | 11.43219899 |
| Value | Count | Frequency (%) | |
| 0 | 7514 | 8.3% | |
| 6.933423026 | 133 | 0.1% | |
| 7.001245622 | 126 | 0.1% | |
| 5.953243334 | 121 | 0.1% | |
| 10.21431226 | 120 | 0.1% | |
| 7.794823152 | 118 | 0.1% | |
| 8.646289765 | 117 | 0.1% | |
| 6.520621128 | 116 | 0.1% | |
| 11.82188701 | 113 | 0.1% | |
| 7.071573364 | 110 | 0.1% | |
| Other values (2214) | 82109 | 90.5% |
| Value | Count | Frequency (%) | |
| 0 | 7514 | 8.3% | |
| 0.6931471806 | 25 | < 0.1% | |
| 1.098612289 | 20 | < 0.1% | |
| 1.386294361 | 16 | < 0.1% | |
| 1.791759469 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15.29536379 | 60 | 0.1% | |
| 15.01487305 | 60 | 0.1% | |
| 14.99096382 | 60 | 0.1% | |
| 14.30600347 | 60 | 0.1% | |
| 14.2794653 | 60 | 0.1% |
| Distinct count | 2755 |
|---|---|
| Unique (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 887840.7473 |
|---|---|
| Minimum | 0.0 |
| Maximum | 46044870.0 |
| Zeros | 3745 |
| Zeros (%) | 4.1% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 735.4 |
| Q1 | 11172 |
| median | 62310 |
| Q3 | 598950 |
| 95-th percentile | 4533600 |
| Maximum | 46044870 |
| Range | 46044870 |
| Interquartile range (IQR) | 587778 |
Descriptive statistics
| Standard deviation | 2701115.98 |
|---|---|
| Coefficient of variation (CV) | 3.042342885 |
| Kurtosis | 98.28656155 |
| Mean | 887840.7473 |
| Median Absolute Deviation (MAD) | 1208727.411 |
| Skewness | 8.102139676 |
| Sum | 8.052449226e+10 |
| Variance | 7.296027539e+12 |
| Value | Count | Frequency (%) | |
| 0 | 3745 | 4.1% | |
| 12687 | 106 | 0.1% | |
| 9622 | 94 | 0.1% | |
| 11371 | 87 | 0.1% | |
| 5770 | 83 | 0.1% | |
| 17716 | 83 | 0.1% | |
| 4532 | 79 | 0.1% | |
| 454770 | 79 | 0.1% | |
| 3530 | 70 | 0.1% | |
| 8341 | 62 | 0.1% | |
| Other values (2745) | 86209 | 95.1% |
| Value | Count | Frequency (%) | |
| 0 | 3745 | 4.1% | |
| 1 | 59 | 0.1% | |
| 3 | 3 | < 0.1% | |
| 10 | 50 | 0.1% | |
| 13 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 46044870 | 60 | 0.1% | |
| 37611900 | 60 | 0.1% | |
| 35771040 | 60 | 0.1% | |
| 19037280 | 60 | 0.1% | |
| 16971570 | 60 | 0.1% |
| Distinct count | 2212 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.423440842 |
|---|---|
| Minimum | 0.0 |
| Maximum | 15.55008061287187 |
| Zeros | 8480 |
| Zeros (%) | 9.3% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6.877296071 |
| median | 8.674367866 |
| Q3 | 11.04756703 |
| 95-th percentile | 13.16260472 |
| Maximum | 15.55008061 |
| Range | 15.55008061 |
| Interquartile range (IQR) | 4.170270959 |
Descriptive statistics
| Standard deviation | 3.563217731 |
|---|---|
| Coefficient of variation (CV) | 0.4230121393 |
| Kurtosis | 0.5559346564 |
| Mean | 8.423440842 |
| Median Absolute Deviation (MAD) | 2.704257467 |
| Skewness | -0.9017921421 |
| Sum | 763980.8141 |
| Variance | 12.6965206 |
| Value | Count | Frequency (%) | |
| 0 | 8480 | 9.3% | |
| 8.118505068 | 154 | 0.2% | |
| 4.795790546 | 151 | 0.2% | |
| 6.931471806 | 147 | 0.2% | |
| 6.401917197 | 142 | 0.2% | |
| 5.198497031 | 137 | 0.2% | |
| 6.638567789 | 129 | 0.1% | |
| 6.583409222 | 119 | 0.1% | |
| 8.246695944 | 118 | 0.1% | |
| 7.245655068 | 117 | 0.1% | |
| Other values (2202) | 81003 | 89.3% |
| Value | Count | Frequency (%) | |
| 0 | 8480 | 9.3% | |
| 0.6931471806 | 1 | < 0.1% | |
| 1.098612289 | 77 | 0.1% | |
| 1.386294361 | 26 | < 0.1% | |
| 1.609437912 | 10 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15.55008061 | 60 | 0.1% | |
| 15.28981603 | 60 | 0.1% | |
| 15.25505678 | 60 | 0.1% | |
| 14.51385471 | 60 | 0.1% | |
| 14.47747714 | 60 | 0.1% |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 80310 |
| Missing (%) | 88.5% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | 329 |
| Value | Count | Frequency (%) | |
| 0 | 10058 | 11.1% | |
| 1 | 329 | 0.4% | |
| (Missing) | 80310 | 88.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.656427445 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 80326 |
| Missing (%) | 88.6% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | 644 |
| Value | Count | Frequency (%) | |
| 0 | 9727 | 10.7% | |
| 1 | 644 | 0.7% | |
| (Missing) | 80326 | 88.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.65695668 |
| Min length | 1 |
| Distinct count | 54 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 41213 |
| Missing (%) | 45.4% |
| Memory size | 708.6 KiB |
| 01.01.1995 | |
|---|---|
| 01.01.2000 | 4298 |
| 01.03.2001 | 3333 |
| 01.03.1999 | 2760 |
| 01.03.2002 | 2118 |
| Other values (48) |
| Value | Count | Frequency (%) | |
| 01.01.1995 | 23781 | 26.2% | |
| 01.01.2000 | 4298 | 4.7% | |
| 01.03.2001 | 3333 | 3.7% | |
| 01.03.1999 | 2760 | 3.0% | |
| 01.03.2002 | 2118 | 2.3% | |
| 01.01.2009 | 1418 | 1.6% | |
| 01.05.2006 | 1402 | 1.5% | |
| 01.03.2008 | 1070 | 1.2% | |
| 15.01.2015 | 853 | 0.9% | |
| 01.01.2010 | 790 | 0.9% | |
| Other values (43) | 7661 | 8.4% | |
| (Missing) | 41213 | 45.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 7.273581265 |
| Min length | 4 |
| Distinct count | 561 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 3542 |
| Missing (%) | 3.9% |
| Memory size | 708.6 KiB |
| Hypertension | 2963 |
|---|---|
| Bact.Inf., Sys. | 1889 |
| Statines | 1705 |
| EPILEPSY- Anticonvulsants | 1515 |
| Pain, Mod/Sev | 1352 |
| Other values (555) |
| Value | Count | Frequency (%) | |
| Hypertension | 2963 | 3.3% | |
| Bact.Inf., Sys. | 1889 | 2.1% | |
| Statines | 1705 | 1.9% | |
| EPILEPSY- Anticonvulsants | 1515 | 1.7% | |
| Pain, Mod/Sev | 1352 | 1.5% | |
| הורדת חום ושיכוך כאב | 1309 | 1.4% | |
| Depression-SSRI | 1217 | 1.3% | |
| Diabetes Mell. | 1027 | 1.1% | |
| BPH | 965 | 1.1% | |
| טיפול אנטי פטרייתי | 952 | 1.0% | |
| Other values (550) | 72261 | 79.7% | |
| (Missing) | 3542 | 3.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 30 |
|---|---|
| Mean length | 15.21452749 |
| Min length | 2 |
| Distinct count | 306 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 6891 |
| Missing (%) | 7.6% |
| Memory size | 708.6 KiB |
| Hypertension | 3180 |
|---|---|
| Diabetes Mell. | 3005 |
| food adittive | 2471 |
| Not Designated | 2361 |
| Epilepsy | 2016 |
| Other values (300) |
| Value | Count | Frequency (%) | |
| Hypertension | 3180 | 3.5% | |
| Diabetes Mell. | 3005 | 3.3% | |
| food adittive | 2471 | 2.7% | |
| Not Designated | 2361 | 2.6% | |
| Epilepsy | 2016 | 2.2% | |
| Bact.Inf., Sys. | 1893 | 2.1% | |
| cosmetics | 1868 | 2.1% | |
| Statines | 1705 | 1.9% | |
| Antidepressants | 1683 | 1.9% | |
| Pain, Mild/Mod. | 1602 | 1.8% | |
| Other values (295) | 62022 | 68.4% | |
| (Missing) | 6891 | 7.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 30 |
|---|---|
| Mean length | 12.00066154 |
| Min length | 3 |
| Distinct count | 90697 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54602.10858 |
|---|---|
| Minimum | 0 |
| Maximum | 109199 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5442.8 |
| Q1 | 27270 |
| median | 54644 |
| Q3 | 81884 |
| 95-th percentile | 103723.2 |
| Maximum | 109199 |
| Range | 109199 |
| Interquartile range (IQR) | 54614 |
Descriptive statistics
| Standard deviation | 31526.67024 |
|---|---|
| Coefficient of variation (CV) | 0.5773892449 |
| Kurtosis | -1.200406177 |
| Mean | 54602.10858 |
| Median Absolute Deviation (MAD) | 27307.16505 |
| Skewness | -0.001034537182 |
| Sum | 4952247442 |
| Variance | 993930936.5 |
| Value | Count | Frequency (%) | |
| 6141 | 1 | < 0.1% | |
| 101028 | 1 | < 0.1% | |
| 60104 | 1 | < 0.1% | |
| 58057 | 1 | < 0.1% | |
| 64202 | 1 | < 0.1% | |
| 62155 | 1 | < 0.1% | |
| 49869 | 1 | < 0.1% | |
| 56014 | 1 | < 0.1% | |
| 8913 | 1 | < 0.1% | |
| 15058 | 1 | < 0.1% | |
| Other values (90687) | 90687 | > 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 109199 | 1 | < 0.1% | |
| 109198 | 1 | < 0.1% | |
| 109197 | 1 | < 0.1% | |
| 109196 | 1 | < 0.1% | |
| 109195 | 1 | < 0.1% |
| Distinct count | 879 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| Minimum | 2006-03-06 00:00:00 |
|---|---|
| Maximum | 2019-08-19 00:00:00 |
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 89409 |
| Missing (%) | 98.6% |
| Memory size | 708.6 KiB |
| 01.02.2015 | |
|---|---|
| 01.06.2017 | 99 |
| 01.03.2016 | 98 |
| 01.10.2018 | 96 |
| 01.03.2017 | 81 |
| Other values (24) |
| Value | Count | Frequency (%) | |
| 01.02.2015 | 168 | 0.2% | |
| 01.06.2017 | 99 | 0.1% | |
| 01.03.2016 | 98 | 0.1% | |
| 01.10.2018 | 96 | 0.1% | |
| 01.03.2017 | 81 | 0.1% | |
| 01.09.2019 | 65 | 0.1% | |
| 01.12.2022 | 61 | 0.1% | |
| 01.05.2020 | 60 | 0.1% | |
| 01.07.2018 | 59 | 0.1% | |
| 01.05.2019 | 53 | 0.1% | |
| Other values (19) | 448 | 0.5% | |
| (Missing) | 89409 | 98.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.085206787 |
| Min length | 4 |
Exceptional_policy
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | 9680 |
| Value | Count | Frequency (%) | |
| 0 | 81017 | 89.3% | |
| 1 | 9680 | 10.7% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 86837 |
| Missing (%) | 95.7% |
| Memory size | 708.6 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 3860 | 4.3% | |
| (Missing) | 86837 | 95.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.872322128 |
| Min length | 1 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 52945 |
| Missing (%) | 58.4% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 17 | 22 |
| 15 | 6 |
| Value | Count | Frequency (%) | |
| 0 | 37724 | 41.6% | |
| 17 | 22 | < 0.1% | |
| 15 | 6 | < 0.1% | |
| (Missing) | 52945 | 58.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.751579435 |
| Min length | 1 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 6 | 842 |
| 2 | 378 |
| 1 | 205 |
| Value | Count | Frequency (%) | |
| 0 | 89272 | 98.4% | |
| 6 | 842 | 0.9% | |
| 2 | 378 | 0.4% | |
| 1 | 205 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 6 | 842 |
| 2 | 378 |
| 1 | 205 |
| Value | Count | Frequency (%) | |
| 0 | 89272 | 98.4% | |
| 6 | 842 | 0.9% | |
| 2 | 378 | 0.4% | |
| 1 | 205 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 680 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 53724 |
| Missing (%) | 59.2% |
| Memory size | 708.6 KiB |
| 3999001541 | 186 |
|---|---|
| 3999001291 | 179 |
| 3999019172 | 178 |
| 3999001511 | 177 |
| 3999001491 | 176 |
| Other values (674) |
| Value | Count | Frequency (%) | |
| 3999001541 | 186 | 0.2% | |
| 3999001291 | 179 | 0.2% | |
| 3999019172 | 178 | 0.2% | |
| 3999001511 | 177 | 0.2% | |
| 3999001491 | 176 | 0.2% | |
| 3999001490 | 174 | 0.2% | |
| 3999001542 | 171 | 0.2% | |
| 3999001150 | 171 | 0.2% | |
| 3999003522 | 167 | 0.2% | |
| 3999001280 | 165 | 0.2% | |
| Other values (669) | 35229 | 38.8% | |
| (Missing) | 53724 | 59.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 10 |
|---|---|
| Mean length | 6.445924341 |
| Min length | 4 |
| Distinct count | 2253 |
|---|---|
| Unique (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.347757278 |
|---|---|
| Minimum | 0.0 |
| Maximum | 15.681570278478281 |
| Zeros | 10370 |
| Zeros (%) | 11.4% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7.132497552 |
| median | 8.650149419 |
| Q3 | 11.09363016 |
| 95-th percentile | 13.09956751 |
| Maximum | 15.68157028 |
| Range | 15.68157028 |
| Interquartile range (IQR) | 3.961132607 |
Descriptive statistics
| Standard deviation | 3.687010887 |
|---|---|
| Coefficient of variation (CV) | 0.4416768198 |
| Kurtosis | 0.5326076753 |
| Mean | 8.347757278 |
| Median Absolute Deviation (MAD) | 2.729885759 |
| Skewness | -0.9806135714 |
| Sum | 757116.5418 |
| Variance | 13.59404928 |
| Value | Count | Frequency (%) | |
| 0 | 10370 | 11.4% | |
| 6.775366091 | 130 | 0.1% | |
| 5.993961427 | 120 | 0.1% | |
| 8.567696174 | 120 | 0.1% | |
| 8.802071337 | 120 | 0.1% | |
| 8.896588072 | 120 | 0.1% | |
| 7.700295203 | 117 | 0.1% | |
| 10.63135012 | 116 | 0.1% | |
| 11.21682136 | 115 | 0.1% | |
| 7.843064017 | 114 | 0.1% | |
| Other values (2243) | 79255 | 87.4% |
| Value | Count | Frequency (%) | |
| 0 | 10370 | 11.4% | |
| 1.098612289 | 8 | < 0.1% | |
| 1.791759469 | 59 | 0.1% | |
| 1.945910149 | 32 | < 0.1% | |
| 2.079441542 | 13 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15.68157028 | 60 | 0.1% | |
| 15.66207555 | 60 | 0.1% | |
| 15.09810996 | 60 | 0.1% | |
| 14.79540725 | 60 | 0.1% | |
| 14.71774334 | 60 | 0.1% |
| Distinct count | 32 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6161149977 |
|---|---|
| Minimum | 0.0 |
| Maximum | 6.668228248417403 |
| Zeros | 32934 |
| Zeros (%) | 36.3% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.6931471806 |
| Q3 | 1.098612289 |
| 95-th percentile | 1.386294361 |
| Maximum | 6.668228248 |
| Range | 6.668228248 |
| Interquartile range (IQR) | 1.098612289 |
Descriptive statistics
| Standard deviation | 0.5586083026 |
|---|---|
| Coefficient of variation (CV) | 0.9066624002 |
| Kurtosis | 3.50920502 |
| Mean | 0.6161149977 |
| Median Absolute Deviation (MAD) | 0.4474487874 |
| Skewness | 0.8964444332 |
| Sum | 55879.78195 |
| Variance | 0.3120432357 |
| Value | Count | Frequency (%) | |
| 0 | 32934 | 36.3% | |
| 0.6931471806 | 30986 | 34.2% | |
| 1.098612289 | 16412 | 18.1% | |
| 1.386294361 | 6882 | 7.6% | |
| 1.609437912 | 1739 | 1.9% | |
| 1.791759469 | 626 | 0.7% | |
| 1.945910149 | 244 | 0.3% | |
| 2.079441542 | 157 | 0.2% | |
| 2.197224577 | 121 | 0.1% | |
| 2.397895273 | 104 | 0.1% | |
| Other values (22) | 492 | 0.5% |
| Value | Count | Frequency (%) | |
| 0 | 32934 | 36.3% | |
| 0.6931471806 | 30986 | 34.2% | |
| 1.098612289 | 16412 | 18.1% | |
| 1.386294361 | 6882 | 7.6% | |
| 1.609437912 | 1739 | 1.9% |
| Value | Count | Frequency (%) | |
| 6.668228248 | 6 | < 0.1% | |
| 5.545177444 | 2 | < 0.1% | |
| 4.983606622 | 18 | < 0.1% | |
| 4.700480366 | 15 | < 0.1% | |
| 4.59511985 | 21 | < 0.1% |
Item_in_health_basket
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 155 |
| Missing (%) | 0.2% |
| Memory size | 708.6 KiB |
| 1 | |
|---|---|
| 0 | |
| (Missing) | 155 |
| Value | Count | Frequency (%) | |
| 1 | 56296 | 62.1% | |
| 0 | 34246 | 37.8% | |
| (Missing) | 155 | 0.2% |
Item_Type
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 405 |
| Missing (%) | 0.4% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | 252 |
| 6 | 60 |
| 3 | 60 |
| Value | Count | Frequency (%) | |
| 0 | 89920 | 99.1% | |
| 1 | 252 | 0.3% | |
| 6 | 60 | 0.1% | |
| 3 | 60 | 0.1% | |
| (Missing) | 405 | 0.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
Loading_group
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 23 | |
|---|---|
| 11 | 3303 |
| 25 | 2814 |
| 13 | 1700 |
| 24 | 1186 |
| Other values (7) | 2858 |
| Value | Count | Frequency (%) | |
| 23 | 78836 | 86.9% | |
| 11 | 3303 | 3.6% | |
| 25 | 2814 | 3.1% | |
| 13 | 1700 | 1.9% | |
| 24 | 1186 | 1.3% | |
| 12 | 839 | 0.9% | |
| 22 | 748 | 0.8% | |
| 15 | 595 | 0.7% | |
| 14 | 333 | 0.4% | |
| 19 | 206 | 0.2% | |
| Other values (2) | 137 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 2 |
|---|---|
| Mean length | 1.998544605 |
| Min length | 1 |
| Distinct count | 306 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 6891 |
| Missing (%) | 7.6% |
| Memory size | 708.6 KiB |
| 13 | 3180 |
|---|---|
| 12 | 3005 |
| 393 | 2471 |
| 0 | 2361 |
| 14 | 2016 |
| Other values (300) |
| Value | Count | Frequency (%) | |
| 13 | 3180 | 3.5% | |
| 12 | 3005 | 3.3% | |
| 393 | 2471 | 2.7% | |
| 0 | 2361 | 2.6% | |
| 14 | 2016 | 2.2% | |
| 60 | 1893 | 2.1% | |
| 392 | 1868 | 2.1% | |
| 432 | 1705 | 1.9% | |
| 420 | 1683 | 1.9% | |
| 54 | 1602 | 1.8% | |
| Other values (295) | 62022 | 68.4% | |
| (Missing) | 6891 | 7.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.558805694 |
| Min length | 1 |
Material_Type
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| ZHW1 | |
|---|---|
| ZHW3 | 6697 |
| ZUB1 | 243 |
| Value | Count | Frequency (%) | |
| ZHW1 | 83757 | 92.3% | |
| ZHW3 | 6697 | 7.4% | |
| ZUB1 | 243 | 0.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 07/2018 | 3186 |
|---|---|
| 01/2019 | 3150 |
| 08/2018 | 3131 |
| 10/2018 | 3127 |
| 07/2019 | 3114 |
| Other values (25) |
| Value | Count | Frequency (%) | |
| 07/2018 | 3186 | 3.5% | |
| 01/2019 | 3150 | 3.5% | |
| 08/2018 | 3131 | 3.5% | |
| 10/2018 | 3127 | 3.4% | |
| 07/2019 | 3114 | 3.4% | |
| 01/2018 | 3107 | 3.4% | |
| 10/2017 | 3087 | 3.4% | |
| 05/2018 | 3086 | 3.4% | |
| 09/2019 | 3085 | 3.4% | |
| 03/2019 | 3082 | 3.4% | |
| Other values (20) | 59542 | 65.6% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 7 |
|---|---|
| Mean length | 7 |
| Min length | 7 |
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 07/2018 | 3186 |
|---|---|
| 01/2019 | 3150 |
| 08/2018 | 3131 |
| 10/2018 | 3127 |
| 07/2019 | 3114 |
| Other values (25) |
| Value | Count | Frequency (%) | |
| 07/2018 | 3186 | 3.5% | |
| 01/2019 | 3150 | 3.5% | |
| 08/2018 | 3131 | 3.5% | |
| 10/2018 | 3127 | 3.4% | |
| 07/2019 | 3114 | 3.4% | |
| 01/2018 | 3107 | 3.4% | |
| 10/2017 | 3087 | 3.4% | |
| 05/2018 | 3086 | 3.4% | |
| 09/2019 | 3085 | 3.4% | |
| 03/2019 | 3082 | 3.4% | |
| Other values (20) | 59542 | 65.6% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 7 |
|---|---|
| Mean length | 7 |
| Min length | 7 |
Must_prescribe
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 56 |
| Missing (%) | 0.1% |
| Memory size | 708.6 KiB |
| 1 | |
|---|---|
| 0 | |
| (Missing) | 56 |
| Value | Count | Frequency (%) | |
| 1 | 57411 | 63.3% | |
| 0 | 33230 | 36.6% | |
| (Missing) | 56 | 0.1% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 41313 |
| Missing (%) | 45.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1018751012 |
|---|---|
| Minimum | 0.0 |
| Maximum | 5.0 |
| Zeros | 46358 |
| Zeros (%) | 51.1% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4602865691 |
|---|---|
| Coefficient of variation (CV) | 4.518145881 |
| Kurtosis | 39.7921035 |
| Mean | 0.1018751012 |
| Median Absolute Deviation (MAD) | 0.1912654278 |
| Skewness | 5.756198531 |
| Sum | 5031 |
| Variance | 0.2118637257 |
| Value | Count | Frequency (%) | |
| 0 | 46358 | 51.1% | |
| 1 | 1700 | 1.9% | |
| 2 | 839 | 0.9% | |
| 3 | 391 | 0.4% | |
| 5 | 96 | 0.1% | |
| (Missing) | 41313 | 45.6% |
| Value | Count | Frequency (%) | |
| 0 | 46358 | 51.1% | |
| 1 | 1700 | 1.9% | |
| 2 | 839 | 0.9% | |
| 3 | 391 | 0.4% | |
| 5 | 96 | 0.1% |
| Value | Count | Frequency (%) | |
| 5 | 96 | 0.1% | |
| 3 | 391 | 0.4% | |
| 2 | 839 | 0.9% | |
| 1 | 1700 | 1.9% | |
| 0 | 46358 | 51.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 7350 |
|---|
| Value | Count | Frequency (%) | |
| 7350 | 90697 | 100.0% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Distinct count | 2163 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.140049537 |
|---|---|
| Minimum | 0.0 |
| Maximum | 15.2747725806165 |
| Zeros | 8934 |
| Zeros (%) | 9.9% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6.613384218 |
| median | 8.387312271 |
| Q3 | 10.73832959 |
| 95-th percentile | 12.80583454 |
| Maximum | 15.27477258 |
| Range | 15.27477258 |
| Interquartile range (IQR) | 4.12494537 |
Descriptive statistics
| Standard deviation | 3.506519381 |
|---|---|
| Coefficient of variation (CV) | 0.4307737152 |
| Kurtosis | 0.4705409472 |
| Mean | 8.140049537 |
| Median Absolute Deviation (MAD) | 2.66813448 |
| Skewness | -0.8677243096 |
| Sum | 738278.0729 |
| Variance | 12.29567817 |
| Value | Count | Frequency (%) | |
| 0 | 8934 | 9.9% | |
| 6.442540166 | 159 | 0.2% | |
| 6.144185634 | 141 | 0.2% | |
| 7.290974778 | 139 | 0.2% | |
| 7.166265974 | 137 | 0.2% | |
| 6.156978986 | 130 | 0.1% | |
| 6.395261598 | 125 | 0.1% | |
| 8.839856233 | 120 | 0.1% | |
| 8.239065332 | 120 | 0.1% | |
| 8.487970333 | 120 | 0.1% | |
| Other values (2153) | 80572 | 88.8% |
| Value | Count | Frequency (%) | |
| 0 | 8934 | 9.9% | |
| 0.6931471806 | 2 | < 0.1% | |
| 1.386294361 | 1 | < 0.1% | |
| 1.609437912 | 1 | < 0.1% | |
| 1.791759469 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15.27477258 | 60 | 0.1% | |
| 14.94489451 | 60 | 0.1% | |
| 14.8846961 | 60 | 0.1% | |
| 14.28658923 | 60 | 0.1% | |
| 14.25602938 | 60 | 0.1% |
PRICE
Real number (ℝ≥0)
| Distinct count | 1453 |
|---|---|
| Unique (%) | 1.6% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.856337958 |
|---|---|
| Minimum | 0.009950330853168092 |
| Maximum | 9.48095970022173 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0.009950330853 |
|---|---|
| 5-th percentile | 0.1310282624 |
| Q1 | 0.3920420878 |
| median | 1.757857918 |
| Q3 | 2.857618971 |
| 95-th percentile | 4.380149875 |
| Maximum | 9.4809597 |
| Range | 9.471009369 |
| Interquartile range (IQR) | 2.465576884 |
Descriptive statistics
| Standard deviation | 1.516207124 |
|---|---|
| Coefficient of variation (CV) | 0.8167732161 |
| Kurtosis | 0.8650471867 |
| Mean | 1.856337958 |
| Median Absolute Deviation (MAD) | 1.259478842 |
| Skewness | 0.8631057827 |
| Sum | 168356.8584 |
| Variance | 2.298884044 |
| Value | Count | Frequency (%) | |
| 0.1310282624 | 1143 | 1.3% | |
| 0.1484200051 | 893 | 1.0% | |
| 0.1397619424 | 881 | 1.0% | |
| 0.2851789422 | 873 | 1.0% | |
| 0.1823215568 | 862 | 1.0% | |
| 0.2546422184 | 854 | 0.9% | |
| 0.1043600153 | 846 | 0.9% | |
| 0.4121096508 | 762 | 0.8% | |
| 2.541601993 | 733 | 0.8% | |
| 0.0953101798 | 715 | 0.8% | |
| Other values (1442) | 82131 | 90.6% |
| Value | Count | Frequency (%) | |
| 0.009950330853 | 173 | 0.2% | |
| 0.02955880224 | 195 | 0.2% | |
| 0.03922071315 | 151 | 0.2% | |
| 0.04879016417 | 210 | 0.2% | |
| 0.05826890812 | 177 | 0.2% |
| Value | Count | Frequency (%) | |
| 9.4809597 | 1 | < 0.1% | |
| 9.431307156 | 28 | < 0.1% | |
| 9.256069666 | 4 | < 0.1% | |
| 9.145556487 | 5 | < 0.1% | |
| 9.015209525 | 2 | < 0.1% |
| Distinct count | 1846 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.388497516 |
|---|---|
| Minimum | 0.0 |
| Maximum | 10.807915397787752 |
| Zeros | 1324 |
| Zeros (%) | 1.5% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.16938136 |
| Q1 | 2.151762203 |
| median | 2.85532012 |
| Q3 | 4.281791849 |
| 95-th percentile | 7.335086244 |
| Maximum | 10.8079154 |
| Range | 10.8079154 |
| Interquartile range (IQR) | 2.130029646 |
Descriptive statistics
| Standard deviation | 1.857490182 |
|---|---|
| Coefficient of variation (CV) | 0.548175164 |
| Kurtosis | 0.645013535 |
| Mean | 3.388497516 |
| Median Absolute Deviation (MAD) | 1.448163948 |
| Skewness | 0.9846069822 |
| Sum | 307313.0052 |
| Variance | 3.450269775 |
| Value | Count | Frequency (%) | |
| 0 | 1324 | 1.5% | |
| 1.757857918 | 1074 | 1.2% | |
| 1.648658626 | 922 | 1.0% | |
| 2.541601993 | 649 | 0.7% | |
| 2.791165108 | 635 | 0.7% | |
| 1.458615023 | 611 | 0.7% | |
| 2.272125886 | 599 | 0.7% | |
| 1.945910149 | 583 | 0.6% | |
| 1.902107526 | 481 | 0.5% | |
| 1.386294361 | 480 | 0.5% | |
| Other values (1835) | 83335 | 91.9% |
| Value | Count | Frequency (%) | |
| 0 | 1324 | 1.5% | |
| 0.02955880224 | 52 | 0.1% | |
| 0.06765864847 | 60 | 0.1% | |
| 0.08617769624 | 75 | 0.1% | |
| 0.0953101798 | 179 | 0.2% |
| Value | Count | Frequency (%) | |
| 10.8079154 | 4 | < 0.1% | |
| 10.62652188 | 1 | < 0.1% | |
| 10.46598376 | 5 | < 0.1% | |
| 10.32333606 | 1 | < 0.1% | |
| 10.20502815 | 7 | < 0.1% |
Pure_OTC
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 67205 | 74.1% | |
| 1 | 23492 | 25.9% |
| Distinct count | 54 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.359293924 |
|---|---|
| Minimum | 0.0 |
| Maximum | 6.1070228877422545 |
| Zeros | 1324 |
| Zeros (%) | 1.5% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.6931471806 |
| Q1 | 0.6931471806 |
| median | 3.044522438 |
| Q3 | 3.433987204 |
| 95-th percentile | 4.510859507 |
| Maximum | 6.107022888 |
| Range | 6.107022888 |
| Interquartile range (IQR) | 2.740840024 |
Descriptive statistics
| Standard deviation | 1.438830906 |
|---|---|
| Coefficient of variation (CV) | 0.6098565726 |
| Kurtosis | -1.565341213 |
| Mean | 2.359293924 |
| Median Absolute Deviation (MAD) | 1.345052332 |
| Skewness | -0.1025959404 |
| Sum | 213980.881 |
| Variance | 2.070234377 |
| Value | Count | Frequency (%) | |
| 0.6931471806 | 32341 | 35.7% | |
| 3.433987204 | 20321 | 22.4% | |
| 3.36729583 | 6078 | 6.7% | |
| 4.110873864 | 4679 | 5.2% | |
| 3.044522438 | 4570 | 5.0% | |
| 4.615120517 | 3030 | 3.3% | |
| 2.397895273 | 2182 | 2.4% | |
| 3.931825633 | 2030 | 2.2% | |
| 1.791759469 | 1623 | 1.8% | |
| 4.043051268 | 1516 | 1.7% | |
| Other values (44) | 12327 | 13.6% |
| Value | Count | Frequency (%) | |
| 0 | 1324 | 1.5% | |
| 0.6931471806 | 32341 | 35.7% | |
| 1.098612289 | 1026 | 1.1% | |
| 1.386294361 | 663 | 0.7% | |
| 1.609437912 | 1165 | 1.3% |
| Value | Count | Frequency (%) | |
| 6.107022888 | 1 | < 0.1% | |
| 5.993961427 | 36 | < 0.1% | |
| 5.602118821 | 3 | < 0.1% | |
| 5.416100402 | 3 | < 0.1% | |
| 5.351858133 | 30 | < 0.1% |
| Distinct count | 54 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.359293924 |
|---|---|
| Minimum | 0.0 |
| Maximum | 6.1070228877422545 |
| Zeros | 1324 |
| Zeros (%) | 1.5% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.6931471806 |
| Q1 | 0.6931471806 |
| median | 3.044522438 |
| Q3 | 3.433987204 |
| 95-th percentile | 4.510859507 |
| Maximum | 6.107022888 |
| Range | 6.107022888 |
| Interquartile range (IQR) | 2.740840024 |
Descriptive statistics
| Standard deviation | 1.438830906 |
|---|---|
| Coefficient of variation (CV) | 0.6098565726 |
| Kurtosis | -1.565341213 |
| Mean | 2.359293924 |
| Median Absolute Deviation (MAD) | 1.345052332 |
| Skewness | -0.1025959404 |
| Sum | 213980.881 |
| Variance | 2.070234377 |
| Value | Count | Frequency (%) | |
| 0.6931471806 | 32341 | 35.7% | |
| 3.433987204 | 20321 | 22.4% | |
| 3.36729583 | 6078 | 6.7% | |
| 4.110873864 | 4679 | 5.2% | |
| 3.044522438 | 4570 | 5.0% | |
| 4.615120517 | 3030 | 3.3% | |
| 2.397895273 | 2182 | 2.4% | |
| 3.931825633 | 2030 | 2.2% | |
| 1.791759469 | 1623 | 1.8% | |
| 4.043051268 | 1516 | 1.7% | |
| Other values (44) | 12327 | 13.6% |
| Value | Count | Frequency (%) | |
| 0 | 1324 | 1.5% | |
| 0.6931471806 | 32341 | 35.7% | |
| 1.098612289 | 1026 | 1.1% | |
| 1.386294361 | 663 | 0.7% | |
| 1.609437912 | 1165 | 1.3% |
| Value | Count | Frequency (%) | |
| 6.107022888 | 1 | < 0.1% | |
| 5.993961427 | 36 | < 0.1% | |
| 5.602118821 | 3 | < 0.1% | |
| 5.416100402 | 3 | < 0.1% | |
| 5.351858133 | 30 | < 0.1% |
| Distinct count | 65 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.007643155 |
|---|---|
| Minimum | 0.0 |
| Maximum | 6.90875477931522 |
| Zeros | 64712 |
| Zeros (%) | 71.3% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1.791759469 |
| 95-th percentile | 4.795790546 |
| Maximum | 6.908754779 |
| Range | 6.908754779 |
| Interquartile range (IQR) | 1.791759469 |
Descriptive statistics
| Standard deviation | 1.769177283 |
|---|---|
| Coefficient of variation (CV) | 1.755757754 |
| Kurtosis | 0.8673295359 |
| Mean | 1.007643155 |
| Median Absolute Deviation (MAD) | 1.443884889 |
| Skewness | 1.507195845 |
| Sum | 91390.21124 |
| Variance | 3.129988259 |
| Value | Count | Frequency (%) | |
| 0 | 64712 | 71.3% | |
| 2.772588722 | 3022 | 3.3% | |
| 4.615120517 | 2390 | 2.6% | |
| 2.397895273 | 2085 | 2.3% | |
| 3.931825633 | 1960 | 2.2% | |
| 3.433987204 | 1905 | 2.1% | |
| 1.791759469 | 1510 | 1.7% | |
| 3.044522438 | 1174 | 1.3% | |
| 1.386294361 | 1057 | 1.2% | |
| 6.216606101 | 992 | 1.1% | |
| Other values (55) | 9890 | 10.9% |
| Value | Count | Frequency (%) | |
| 0 | 64712 | 71.3% | |
| 0.6931471806 | 863 | 1.0% | |
| 1.098612289 | 803 | 0.9% | |
| 1.386294361 | 1057 | 1.2% | |
| 1.609437912 | 145 | 0.2% |
| Value | Count | Frequency (%) | |
| 6.908754779 | 115 | 0.1% | |
| 6.621405652 | 58 | 0.1% | |
| 6.216606101 | 992 | 1.1% | |
| 6.120297419 | 51 | 0.1% | |
| 6.11146734 | 121 | 0.1% |
| Distinct count | 2132 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.916702577 |
|---|---|
| Minimum | 0.0 |
| Maximum | 15.47226783919266 |
| Zeros | 9502 |
| Zeros (%) | 10.5% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6.539585956 |
| median | 8.04462628 |
| Q3 | 10.61849407 |
| 95-th percentile | 12.59795594 |
| Maximum | 15.47226784 |
| Range | 15.47226784 |
| Interquartile range (IQR) | 4.078908112 |
Descriptive statistics
| Standard deviation | 3.492251393 |
|---|---|
| Coefficient of variation (CV) | 0.4411244908 |
| Kurtosis | 0.4302664641 |
| Mean | 7.916702577 |
| Median Absolute Deviation (MAD) | 2.630418858 |
| Skewness | -0.8254522068 |
| Sum | 718021.1736 |
| Variance | 12.19581979 |
| Value | Count | Frequency (%) | |
| 0 | 9502 | 10.5% | |
| 7.119635638 | 136 | 0.1% | |
| 7.239214974 | 130 | 0.1% | |
| 6.135564891 | 126 | 0.1% | |
| 6.602587892 | 122 | 0.1% | |
| 7.493873887 | 121 | 0.1% | |
| 7.400009517 | 120 | 0.1% | |
| 10.8062066 | 120 | 0.1% | |
| 11.87214417 | 119 | 0.1% | |
| 11.31568112 | 119 | 0.1% | |
| Other values (2122) | 80082 | 88.3% |
| Value | Count | Frequency (%) | |
| 0 | 9502 | 10.5% | |
| 0.6931471806 | 19 | < 0.1% | |
| 1.386294361 | 33 | < 0.1% | |
| 1.609437912 | 1 | < 0.1% | |
| 1.791759469 | 21 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15.47226784 | 60 | 0.1% | |
| 15.4438134 | 60 | 0.1% | |
| 15.00171636 | 60 | 0.1% | |
| 14.77718948 | 60 | 0.1% | |
| 14.633735 | 60 | 0.1% |
Seasonality
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 11 |
| Missing (%) | < 0.1% |
| Memory size | 708.6 KiB |
| no | |
|---|---|
| yes | 14012 |
| (Missing) | 11 |
| Value | Count | Frequency (%) | |
| no | 76674 | 84.5% | |
| yes | 14012 | 15.4% | |
| (Missing) | 11 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 90697 | 100.0% |
| Distinct count | 53 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 7904 |
| Missing (%) | 8.7% |
| Memory size | 708.6 KiB |
| TAB | |
|---|---|
| CAP | |
| CR | 4923 |
| COL | 3135 |
| CPL | 2565 |
| Other values (47) |
| Value | Count | Frequency (%) | |
| TAB | 37094 | 40.9% | |
| CAP | 8375 | 9.2% | |
| CR | 4923 | 5.4% | |
| COL | 3135 | 3.5% | |
| CPL | 2565 | 2.8% | |
| GEL | 2051 | 2.3% | |
| OIN | 1977 | 2.2% | |
| SOL | 1789 | 2.0% | |
| INJ | 1639 | 1.8% | |
| LIQ | 1592 | 1.8% | |
| Other values (42) | 17653 | 19.5% | |
| (Missing) | 7904 | 8.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.03286768 |
| Min length | 2 |
| Distinct count | 3207 |
|---|---|
| Unique (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 10000003319 | 60 |
|---|---|
| 10000003879 | 60 |
| 10000003587 | 60 |
| 10000002480 | 60 |
| 10000005211 | 60 |
| Other values (3202) |
| Value | Count | Frequency (%) | |
| 10000003319 | 60 | 0.1% | |
| 10000003879 | 60 | 0.1% | |
| 10000003587 | 60 | 0.1% | |
| 10000002480 | 60 | 0.1% | |
| 10000005211 | 60 | 0.1% | |
| 10000001921 | 60 | 0.1% | |
| 10000006604 | 60 | 0.1% | |
| 10000005414 | 60 | 0.1% | |
| 10000003112 | 60 | 0.1% | |
| 10000004649 | 60 | 0.1% | |
| Other values (3197) | 90097 | 99.3% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 11 |
|---|---|
| Mean length | 11 |
| Min length | 11 |
Sourcing_source
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| ארץ | |
|---|---|
| חו"ל | 554 |
| Value | Count | Frequency (%) | |
| ארץ | 90143 | 99.4% | |
| חו"ל | 554 | 0.6% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.006108251 |
| Min length | 3 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 90697 | 100.0% |
storecode
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 3224 | |
|---|---|
| 3315 |
| Value | Count | Frequency (%) | |
| 3224 | 46054 | 50.8% | |
| 3315 | 44643 | 49.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 7362 |
| Missing (%) | 8.1% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | 333 |
| 3 | 55 |
| 2 | 15 |
| Value | Count | Frequency (%) | |
| 0 | 82932 | 91.4% | |
| 1 | 333 | 0.4% | |
| 3 | 55 | 0.1% | |
| 2 | 15 | < 0.1% | |
| (Missing) | 7362 | 8.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
TranQuantity
Real number (ℝ≥0)
| Distinct count | 1943 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.280400313 |
|---|---|
| Minimum | 0.0 |
| Maximum | 9.455714972131714 |
| Zeros | 447 |
| Zeros (%) | 0.5% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.6931471806 |
| Q1 | 1.386294361 |
| median | 3.044522438 |
| Q3 | 4.86753445 |
| 95-th percentile | 6.862967009 |
| Maximum | 9.455714972 |
| Range | 9.455714972 |
| Interquartile range (IQR) | 3.481240089 |
Descriptive statistics
| Standard deviation | 2.042961548 |
|---|---|
| Coefficient of variation (CV) | 0.6227781227 |
| Kurtosis | -0.8975574893 |
| Mean | 3.280400313 |
| Median Absolute Deviation (MAD) | 1.772392933 |
| Skewness | 0.4249804534 |
| Sum | 297522.4672 |
| Variance | 4.173691889 |
| Value | Count | Frequency (%) | |
| 0.6931471806 | 10802 | 11.9% | |
| 1.098612289 | 7535 | 8.3% | |
| 1.386294361 | 5312 | 5.9% | |
| 1.609437912 | 4111 | 4.5% | |
| 4.110873864 | 3589 | 4.0% | |
| 3.433987204 | 3294 | 3.6% | |
| 1.791759469 | 2936 | 3.2% | |
| 1.945910149 | 2478 | 2.7% | |
| 4.795790546 | 2067 | 2.3% | |
| 4.510859507 | 1843 | 2.0% | |
| Other values (1933) | 46730 | 51.5% |
| Value | Count | Frequency (%) | |
| 0 | 447 | 0.5% | |
| 0.6931471806 | 10802 | 11.9% | |
| 1.098612289 | 7535 | 8.3% | |
| 1.386294361 | 5312 | 5.9% | |
| 1.609437912 | 4111 | 4.5% |
| Value | Count | Frequency (%) | |
| 9.455714972 | 2 | < 0.1% | |
| 9.427143868 | 1 | < 0.1% | |
| 9.412546252 | 1 | < 0.1% | |
| 9.346705246 | 2 | < 0.1% | |
| 9.329455853 | 1 | < 0.1% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 85285 |
| Missing (%) | 94.0% |
| Memory size | 708.6 KiB |
| BOX | |
|---|---|
| TUB | |
| BOT | |
| PKG | 200 |
| BAG | 24 |
| Value | Count | Frequency (%) | |
| BOX | 3632 | 4.0% | |
| TUB | 773 | 0.9% | |
| BOT | 770 | 0.8% | |
| PKG | 200 | 0.2% | |
| BAG | 24 | < 0.1% | |
| KIT | 13 | < 0.1% | |
| (Missing) | 85285 | 94.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.940328787 |
| Min length | 3 |
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 89166 |
| Missing (%) | 98.3% |
| Memory size | 708.6 KiB |
| 01.03.2016 | 132 |
|---|---|
| 01.02.2018 | 117 |
| 01.10.2020 | 113 |
| 01.07.2018 | 107 |
| 01.10.2018 | 96 |
| Other values (27) |
| Value | Count | Frequency (%) | |
| 01.03.2016 | 132 | 0.1% | |
| 01.02.2018 | 117 | 0.1% | |
| 01.10.2020 | 113 | 0.1% | |
| 01.07.2018 | 107 | 0.1% | |
| 01.10.2018 | 96 | 0.1% | |
| 01.05.2020 | 86 | 0.1% | |
| 01.03.2017 | 81 | 0.1% | |
| 01.12.2019 | 71 | 0.1% | |
| 01.03.2020 | 66 | 0.1% | |
| 01.06.2018 | 65 | 0.1% | |
| Other values (22) | 597 | 0.7% | |
| (Missing) | 89166 | 98.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.101282292 |
| Min length | 4 |
| Distinct count | 83 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 86155 |
| Missing (%) | 95.0% |
| Memory size | 708.6 KiB |
| 28.02.2015 | 250 |
|---|---|
| 30.04.2015 | 247 |
| 30.11.2012 | 244 |
| 30.11.2013 | 181 |
| 31.01.2007 | 180 |
| Other values (77) |
| Value | Count | Frequency (%) | |
| 28.02.2015 | 250 | 0.3% | |
| 30.04.2015 | 247 | 0.3% | |
| 30.11.2012 | 244 | 0.3% | |
| 30.11.2013 | 181 | 0.2% | |
| 31.01.2007 | 180 | 0.2% | |
| 30.09.2012 | 142 | 0.2% | |
| 31.10.2013 | 120 | 0.1% | |
| 31.03.2015 | 119 | 0.1% | |
| 31.01.2008 | 113 | 0.1% | |
| 31.05.2014 | 113 | 0.1% | |
| Other values (72) | 2833 | 3.1% | |
| (Missing) | 86155 | 95.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.300473004 |
| Min length | 4 |
| Distinct count | 155 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 594 |
| Missing (%) | 0.7% |
| Memory size | 708.6 KiB |
| 400059 | 8701 |
|---|---|
| 400057 | 4983 |
| 408668 | 4824 |
| 400095 | 4199 |
| 400045 | 3597 |
| Other values (149) |
| Value | Count | Frequency (%) | |
| 400059 | 8701 | 9.6% | |
| 400057 | 4983 | 5.5% | |
| 408668 | 4824 | 5.3% | |
| 400095 | 4199 | 4.6% | |
| 400045 | 3597 | 4.0% | |
| 406885 | 3543 | 3.9% | |
| 407214 | 2828 | 3.1% | |
| 400026 | 2778 | 3.1% | |
| 410232 | 2705 | 3.0% | |
| 400032 | 2203 | 2.4% | |
| Other values (144) | 49742 | 54.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 5.986901441 |
| Min length | 4 |
volume
Real number (ℝ≥0)
| Distinct count | 1928 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.888156056 |
|---|---|
| Minimum | 0.0 |
| Maximum | 9.207736986106068 |
| Zeros | 53 |
| Zeros (%) | 0.1% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.404134279 |
| Q1 | 1.978653888 |
| median | 4.428433007 |
| Q3 | 5.504652444 |
| 95-th percentile | 6.609349243 |
| Maximum | 9.207736986 |
| Range | 9.207736986 |
| Interquartile range (IQR) | 3.525998556 |
Descriptive statistics
| Standard deviation | 1.885215396 |
|---|---|
| Coefficient of variation (CV) | 0.4848610419 |
| Kurtosis | -1.432567435 |
| Mean | 3.888156056 |
| Median Absolute Deviation (MAD) | 1.739452825 |
| Skewness | 0.03042931426 |
| Sum | 352644.0899 |
| Variance | 3.554037091 |
| Value | Count | Frequency (%) | |
| 1.496717042 | 614 | 0.7% | |
| 1.504077397 | 516 | 0.6% | |
| 1.489076556 | 452 | 0.5% | |
| 1.602816036 | 413 | 0.5% | |
| 5.198497031 | 400 | 0.4% | |
| 2.120223535 | 344 | 0.4% | |
| 1.526056303 | 323 | 0.4% | |
| 2.208274414 | 320 | 0.4% | |
| 2.014903021 | 318 | 0.4% | |
| 4.605170186 | 311 | 0.3% | |
| Other values (1918) | 86686 | 95.6% |
| Value | Count | Frequency (%) | |
| 0 | 53 | 0.1% | |
| 0.2037568375 | 2 | < 0.1% | |
| 0.5754891371 | 12 | < 0.1% | |
| 0.6471032421 | 60 | 0.1% | |
| 0.6981347221 | 12 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9.207736986 | 2 | < 0.1% | |
| 9.019058794 | 11 | < 0.1% | |
| 8.42398081 | 60 | 0.1% | |
| 8.384347278 | 17 | < 0.1% | |
| 8.37262974 | 54 | 0.1% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| B | |
|---|---|
| E | |
| A | |
| D | 5580 |
| H | 102 |
| Value | Count | Frequency (%) | |
| B | 43242 | 47.7% | |
| E | 23065 | 25.4% | |
| A | 18708 | 20.6% | |
| D | 5580 | 6.2% | |
| H | 102 | 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
First rows
| A_group_of_materials | ABC | Affiliation_Group | Alternative_purchasing_group | ATC | Basic_unit_of_measure | Budget_Group | Chemical_/_biological | chronic | Consumer_management | consumption | consumption_previous_year | Current_consumption | Dangerous_material_is_charged_with_a_permit | dangerous_substance | Date_of_basket_entry | Description_Alternative_purchasing_group | Description_outline | df_index | Establishment_date_of_the_item | European_patent_expires | Exceptional_policy | For_adults | Form_of_giving | General_purpose | General_purpose_ | GENERY_FATHER | Inventory | Inventory_of_consumption_months | Item_in_health_basket | Item_Type | Loading_group | Main_outline | Material_Type | month_year | month_year_ | Must_prescribe | Narcotic_/_psychotropic | Plant | Prediction | PRICE | Price_for_absolute_packaging | Pure_OTC | Quantity_in_absolute_packaging | Quantity_in_Packaging-Absolute | Quantity_in_packing-relative | Safety_Stock | Seasonality | Send_code_to_Omri | Serving_form | skucode2 | Sourcing_source | status | storecode | Toxic_item | TranQuantity | type_of_packeging | U#S#_Patent_Expires | Validity_of_Ministry_of_Health_registration | VENDOR | volume | Volume_marker | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20140 | B | 15 | 1180 | ATC:G03AA09 | PAC | B | 1.0 | 0.0 | ave | 8.759355 | 83062.0 | 9.046880 | None | None | 01.04.2005 | Oral contraceptive | Oral Contra. | 0 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | None | 9.083870 | 0.693147 | 1.0 | 0.0 | 23 | 171 | ZHW1 | 03/2017 | 03/2017 | 1.0 | 0.0 | 7350.0 | 8.902728 | 2.337952 | 5.286042 | 0.0 | 3.091042 | 3.091042 | 0.000000 | 8.449343 | no | 1.0 | TAB | 10000005719 | ארץ | 1.0 | 3224.0 | 0.0 | 2.484907 | BOX | None | None | 408668 | 4.624973 | B |
| 1 | 20190 | C | 20 | 1054 | ATC:N06AA04 | EA | B | 1.0 | 1.0 | ave | 10.183049 | 306420.0 | 10.460844 | None | None | 01.01.1995 | Depression-Tricyclic | Antidepressants | 1 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | 3999005422 | 11.135333 | 1.098612 | 1.0 | 0.0 | 23 | 420 | ZHW1 | 02/2019 | 02/2019 | 1.0 | 0.0 | 7350.0 | 10.139073 | 0.190620 | 1.987874 | 0.0 | 3.433987 | 3.433987 | 0.000000 | 10.342097 | no | 1.0 | TAB | 10000006427 | ארץ | 1.0 | 3224.0 | 0.0 | 4.795791 | None | None | None | 400095 | 1.554559 | B |
| 2 | 20270 | C | 24 | 1351 | ATC:D08AX08 | EA | E | 1.0 | 0.0 | ave | 7.186901 | 13544.0 | 7.705713 | 0 | 0 | None | חיטוי ידיים | cosmetics | 2 | 2016-05-18 | None | 0.0 | None | None | 0.0 | 0.0 | None | 6.775366 | 0.000000 | 0.0 | 0.0 | 23 | 392 | ZHW1 | 07/2017 | 07/2017 | 0.0 | NaN | 7350.0 | 7.116394 | 2.710713 | 2.710713 | 1.0 | 0.693147 | 0.693147 | 6.216606 | 6.829794 | no | 1.0 | GEL | 10000001880 | ארץ | 1.0 | 3315.0 | 0.0 | 1.098612 | None | None | None | 124207 | 6.848005 | E |
| 3 | 20180 | C | 19 | 1156 | ATC:M01AH01 | EA | B | 1.0 | 0.0 | ave | 10.759476 | 525410.0 | 10.990887 | None | None | None | NSAIDS-COX 2 inhibtors | Rheum. Arth. | 4 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | 3999010655 | 11.378148 | 0.693147 | 0.0 | 0.0 | 23 | 65 | ZHW1 | 02/2017 | 02/2017 | 1.0 | 0.0 | 7350.0 | 10.722695 | 0.444686 | 1.887070 | 0.0 | 2.397895 | 2.397895 | 0.000000 | 10.894125 | no | 1.0 | CAP | 10000006732 | ארץ | 1.0 | 3224.0 | 0.0 | 3.433987 | None | None | None | 400077 | 2.442347 | B |
| 4 | 20120 | B | 13 | 1605 | ATC:C08CA01 | EA | B | 1.0 | 1.0 | ave | 0.000000 | 0.0 | 0.000000 | None | None | 01.01.2000 | Calcium Chanell Blockers | Calcium Chanell Blockers | 5 | 2006-09-26 | None | 0.0 | None | None | 0.0 | 0.0 | 3999019172 | 0.000000 | 0.000000 | 1.0 | 0.0 | 23 | 431 | ZHW1 | 04/2017 | 04/2017 | 1.0 | 0.0 | 7350.0 | 0.000000 | 0.131028 | 1.335001 | 0.0 | 3.044522 | 3.044522 | 0.000000 | 0.000000 | no | 1.0 | TAB | 10000004522 | ארץ | 1.0 | 3315.0 | 0.0 | 8.077447 | None | None | None | 400059 | 1.987874 | B |
| 5 | 10150 | C | 72 | None | ZRP:102UB01 | EA | D | NaN | 1.0 | ave | 0.000000 | 0.0 | 0.000000 | None | None | 01.03.2001 | None | None | 6 | 2009-06-03 | None | 0.0 | None | None | 0.0 | 0.0 | None | 0.000000 | 0.000000 | 1.0 | 0.0 | 23 | None | ZHW3 | 03/2019 | 03/2019 | 1.0 | NaN | 7350.0 | 0.000000 | 3.521348 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | no | 1.0 | None | 10000003897 | ארץ | 1.0 | 3315.0 | NaN | 1.609438 | None | None | None | 400044 | 6.309236 | D |
| 6 | 20220 | C | 22 | 1946 | ATC:S01XA30 | PAC | E | 1.0 | 0.0 | ave | 7.265430 | 17751.0 | 7.524561 | None | None | None | טיפות ליובש בעיניים | Artificial Tears | 7 | 2010-12-27 | None | 0.0 | None | None | 0.0 | 0.0 | None | 7.990577 | 1.098612 | 0.0 | 0.0 | 23 | 128 | ZHW1 | 05/2018 | 05/2018 | 0.0 | NaN | 7350.0 | 7.307202 | 3.286161 | 6.714995 | 1.0 | 3.496508 | 3.496508 | 0.000000 | 7.342779 | no | 1.0 | COL | 10000003478 | ארץ | 1.0 | 3315.0 | 0.0 | 2.397895 | None | None | None | 400006 | 6.226537 | E |
| 7 | 20100 | B | 11 | 1354 | ATC:A01AB09 | EA | B | 1.0 | 0.0 | ave | 8.155075 | 39454.0 | 8.306472 | None | None | 01.01.1995 | טיפול אנטי פטרייתי | Fungal Inf, Oroph. | 8 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | None | 7.828436 | 0.000000 | 1.0 | 0.0 | 23 | 83 | ZHW1 | 01/2018 | 01/2018 | 0.0 | 0.0 | 7350.0 | 8.088255 | 2.643334 | 2.643334 | 0.0 | 0.693147 | 0.693147 | 3.713572 | 7.462215 | no | 1.0 | GEL | 10000006295 | ארץ | 1.0 | 3315.0 | 0.0 | 1.609438 | None | None | 30.04.2012 | 117469 | 5.370638 | B |
| 8 | 10100 | C | 24 | 1429 | ZRP:A21AD | EA | E | NaN | 0.0 | ave | 6.244167 | 5821.0 | 6.569481 | None | None | None | סד תמיכה ליד | None | 9 | 2006-03-06 | None | 0.0 | None | None | 0.0 | 0.0 | None | 7.156956 | 1.098612 | 0.0 | 0.0 | 23 | None | ZHW3 | 05/2018 | 05/2018 | 0.0 | NaN | 7350.0 | 6.180017 | 3.409496 | 3.409496 | 1.0 | 0.693147 | 0.693147 | 0.000000 | 6.410175 | no | 1.0 | None | 10000006992 | ארץ | 1.0 | 3224.0 | NaN | 1.098612 | None | None | None | 400123 | 6.651572 | E |
| 9 | 20190 | C | 20 | 1017 | ATC:N07CA02 | EA | B | 1.0 | 1.0 | ave | 12.116930 | 2158850.0 | 12.316164 | None | None | 01.01.1995 | Antivertigo preparations | Meniere's Dis. | 11 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | None | 12.540135 | 0.693147 | 1.0 | 0.0 | 23 | 209 | ZHW1 | 06/2017 | 06/2017 | 1.0 | 0.0 | 7350.0 | 12.086264 | 0.182322 | 1.791759 | 0.0 | 3.258097 | 3.258097 | 0.000000 | 11.760254 | no | 1.0 | TAB | 10000006644 | ארץ | 1.0 | 3224.0 | 0.0 | 6.356108 | None | None | 30.09.2012 | 401974 | 2.151995 | B |
Last rows
| A_group_of_materials | ABC | Affiliation_Group | Alternative_purchasing_group | ATC | Basic_unit_of_measure | Budget_Group | Chemical_/_biological | chronic | Consumer_management | consumption | consumption_previous_year | Current_consumption | Dangerous_material_is_charged_with_a_permit | dangerous_substance | Date_of_basket_entry | Description_Alternative_purchasing_group | Description_outline | df_index | Establishment_date_of_the_item | European_patent_expires | Exceptional_policy | For_adults | Form_of_giving | General_purpose | General_purpose_ | GENERY_FATHER | Inventory | Inventory_of_consumption_months | Item_in_health_basket | Item_Type | Loading_group | Main_outline | Material_Type | month_year | month_year_ | Must_prescribe | Narcotic_/_psychotropic | Plant | Prediction | PRICE | Price_for_absolute_packaging | Pure_OTC | Quantity_in_absolute_packaging | Quantity_in_Packaging-Absolute | Quantity_in_packing-relative | Safety_Stock | Seasonality | Send_code_to_Omri | Serving_form | skucode2 | Sourcing_source | status | storecode | Toxic_item | TranQuantity | type_of_packeging | U#S#_Patent_Expires | Validity_of_Ministry_of_Health_registration | VENDOR | volume | Volume_marker | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90687 | 20130 | C | 14 | 1517 | ATC:D08AX01 | EA | B | 1.0 | NaN | ave | 7.830028 | 28150.0 | 8.131531 | None | None | 01.01.1995 | תכשיר לחיטוי | Antiseptic | 109189 | 2014-08-24 | None | 0.0 | None | None | 0.0 | 0.0 | None | 8.134468 | 0.693147 | 1.0 | 0.0 | 23 | 135 | ZHW1 | 02/2017 | 02/2017 | NaN | NaN | 7350.0 | 7.789455 | 1.453953 | 1.453953 | 0.0 | 0.693147 | 0.693147 | 4.615121 | 7.473637 | no | 1.0 | SOL | 10000002477 | ארץ | 1.0 | 3315.0 | 0.0 | 1.098612 | None | None | None | 400171 | 5.894403 | B |
| 90688 | 20130 | C | 14 | 1519 | ATC:D02AC02 | EA | E | 1.0 | 0.0 | pred | 6.803505 | 9426.0 | 6.990257 | None | None | None | תכשיר רחצה טיפולי - תינוקות | Dry Skin | 109190 | 2010-06-09 | None | 0.0 | None | None | 0.0 | 0.0 | None | 7.355002 | 0.693147 | 0.0 | 0.0 | 25 | 142 | ZHW1 | 06/2018 | 06/2018 | 0.0 | NaN | 7350.0 | 6.858565 | 3.438493 | 3.438493 | 1.0 | 0.693147 | 0.693147 | 6.216606 | 6.634633 | yes | 1.0 | OIL | 10000003622 | ארץ | 1.0 | 3315.0 | 0.0 | 1.098612 | None | None | None | 400044 | 6.893656 | E |
| 90689 | 20160 | A | 17 | 1651 | ATC:J07AJ52 | EA | B | 2.0 | 0.0 | pred | 0.000000 | 0.0 | 0.000000 | None | None | None | DPT Vac. | DPT Vac. | 109191 | 2011-03-22 | None | 1.0 | None | None | 0.0 | 0.0 | 3999002140 | 0.000000 | 0.000000 | 1.0 | 0.0 | 11 | 96 | ZHW1 | 01/2017 | 01/2017 | 1.0 | NaN | 7350.0 | 0.000000 | 4.161692 | 4.161692 | 0.0 | 0.693147 | 0.693147 | 0.000000 | 0.000000 | no | 1.0 | SRG | 10000003406 | ארץ | 1.0 | 3315.0 | 0.0 | 0.000000 | None | None | None | 400164 | 5.078917 | B |
| 90690 | 20240 | B | 24 | 1401 | ATC:V06DB15 | EA | B | 1.0 | 0.0 | ave | 9.615872 | 196110.0 | 9.891971 | None | None | 01.03.2008 | מזון ייעודי | Metab. Disord. | 109192 | 2014-11-04 | None | 0.0 | None | None | 0.0 | 0.0 | None | 9.292934 | 0.000000 | 1.0 | 0.0 | 25 | 107 | ZHW1 | 04/2019 | 04/2019 | 0.0 | NaN | 7350.0 | 9.701127 | 2.303585 | 2.303585 | 1.0 | 0.693147 | 0.693147 | 5.398163 | 9.095715 | no | 1.0 | LIQ | 10000002408 | ארץ | 1.0 | 3315.0 | 0.0 | 4.110874 | None | None | None | 401882 | 6.144400 | B |
| 90691 | 20180 | B | 19 | 1076 | ATC:M04AC01 | EA | B | 1.0 | 1.0 | ave | 13.046046 | 5311080.0 | 13.336137 | None | None | 01.01.1995 | FMF | Gout | 109193 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | None | 12.731011 | 0.000000 | 1.0 | 0.0 | 23 | 75 | ZHW1 | 01/2017 | 01/2017 | 1.0 | 5.0 | 7350.0 | 13.019404 | 0.300105 | 2.442347 | 0.0 | 3.433987 | 3.433987 | 0.000000 | 12.352901 | no | 1.0 | TAB | 10000006474 | ארץ | 1.0 | 3224.0 | 0.0 | 7.170888 | None | None | None | 400045 | 1.369402 | B |
| 90692 | 20190 | C | 20 | 1823 | ATC:N02AA05 | EA | B | 1.0 | 0.0 | ave | 6.542472 | 8445.0 | 6.759255 | None | None | None | Pain, Mod/Sev | Pain, Mod/Sev | 109195 | 2013-10-14 | None | 0.0 | None | None | 0.0 | 0.0 | None | 6.700731 | 0.693147 | 0.0 | 0.0 | 13 | 59 | ZHW1 | 03/2018 | 03/2018 | 1.0 | 1.0 | 7350.0 | 6.595781 | 3.519277 | 3.519277 | 0.0 | 0.693147 | 0.693147 | 3.433987 | 6.658011 | no | 1.0 | SYR | 10000002704 | ארץ | 1.0 | 3315.0 | 0.0 | 1.609438 | None | None | None | 400045 | 5.129899 | B |
| 90693 | 20130 | C | 14 | 1352 | ATC:D08AG02 | EA | B | 1.0 | 0.0 | pred | 8.718173 | 74934.0 | 8.829226 | None | None | 01.01.1995 | חיטוי נגעים בעור | Antiseptic | 109196 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | 3999021150 | 8.567696 | 0.000000 | 1.0 | 0.0 | 23 | 135 | ZHW1 | 03/2018 | 03/2018 | 0.0 | 0.0 | 7350.0 | 8.502080 | 1.506297 | 1.506297 | 0.0 | 0.693147 | 0.693147 | 2.772589 | 8.145550 | yes | 1.0 | OIN | 10000006784 | ארץ | 1.0 | 3315.0 | 0.0 | 2.995732 | None | None | None | 400057 | 4.934474 | B |
| 90694 | 20100 | C | 11 | 1375 | ATC:A07BB01 | EA | B | 1.0 | 0.0 | ave | 11.155879 | 637500.0 | 11.661699 | None | None | 01.01.1995 | טיפול בשלשול וכאב בטן | Diarrhea | 109197 | 2013-07-01 | None | 0.0 | None | None | 0.0 | 0.0 | 3999002540 | 11.512535 | 0.693147 | 1.0 | 0.0 | 23 | 47 | ZHW1 | 06/2019 | 06/2019 | 0.0 | NaN | 7350.0 | 10.886820 | 0.254642 | 1.916923 | 0.0 | 3.044522 | 3.044522 | 0.000000 | 11.313840 | no | 1.0 | TAB | 10000002793 | ארץ | 1.0 | 3315.0 | 0.0 | 5.484797 | None | None | None | 400026 | 1.953028 | B |
| 90695 | 20150 | C | 16 | 1694 | ATC:H02AB07 | EA | B | 1.0 | 1.0 | ave | 12.040024 | 1913000.0 | 12.307279 | None | None | 01.01.1995 | Glucocorticoid | Glucocorticoid | 109198 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | None | 12.220473 | 0.693147 | 1.0 | 0.0 | 23 | 141 | ZHW1 | 09/2017 | 09/2017 | 1.0 | 0.0 | 7350.0 | 11.995882 | 0.139762 | 2.772589 | 0.0 | 4.615121 | 4.615121 | 0.000000 | 12.104544 | no | 1.0 | TAB | 10000006612 | ארץ | 1.0 | 3224.0 | 0.0 | 5.707110 | None | None | None | 400057 | 0.647103 | B |
| 90696 | 20220 | B | 22 | 1082 | ATC:S01EA05 | EA | A | 1.0 | 1.0 | ave | 9.131622 | 108414.0 | 9.398644 | None | None | 01.10.2005 | Glaucoma alpha 2 agonist | Glaucoma | 109199 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | 3999001444 | 8.757784 | 0.000000 | 1.0 | 0.0 | 23 | 15 | ZHW1 | 09/2019 | 09/2019 | 1.0 | 0.0 | 7350.0 | 9.080687 | 2.855320 | 2.855320 | 0.0 | 0.693147 | 0.693147 | 1.791759 | 8.438583 | no | 1.0 | COL | 10000005869 | ארץ | 1.0 | 3315.0 | 0.0 | 3.713572 | None | None | None | 400036 | 4.418841 | A |